CREATE EXTERNAL TABLE IF NOT EXISTS jms_ods.yl_tms_vehicle_type(
id                                                bigint                        COMMENT '车型编码',
name                                              String                        COMMENT '车型名称',
length                                            String                        COMMENT '车厢长度(m)',
width                                             String                        COMMENT '车厢宽度(m)',
height                                            String                        COMMENT '车厢高度(m)',
weight                                            String                        COMMENT '核载质量(kg)',
volume                                            String                        COMMENT '核定体积',
nuclear_load_num                                  bigint                        COMMENT '核载票数',
create_by                                         bigint                        COMMENT '创建人id',
create_by_name                                    String                        COMMENT '创建人姓名',
create_time                                       timestamp                     COMMENT '创建时间',
update_by                                         bigint                        COMMENT '更新人id',
update_by_name                                    String                        COMMENT '更新人姓名',
update_time                                       timestamp                     COMMENT '更新时间'
)
COMMENT '车型'
PARTITIONED BY (dt STRING COMMENT '更新/创建日期 (yyyy-MM-dd)')
STORED AS PARQUET
LOCATION '/dw/hive/jms_ods.db/external/yl_tms_vehicle_type'
TBLPROPERTIES (
  'parquet.column.index.access'='true'
);
MSCK REPAIR TABLE jms_ods.yl_tms_vehicle_type;
